Proper case T-Sql User Defined Function on Jeff’s SQL Server Blog – This simply attempts to capitalize the first letter of each word for the string passed in. Use it to help clean up some pre-existing data, but don’t use it as a way of presenting your data that is stored improperly since it isn’t exact.

Read more »